package com.anolesoft.ProductRegistration.mapper;

import com.anolesoft.ProductRegistration.entity.ProductionReglstrationRecordDO;
import com.anolesoft.amljmes.test.fenguangyingdu.entity.FenguangYingduRecordDO;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.LocalDateTimeTypeHandler;

/**
 * @author zhj
 * @date 2021/12/22 10:32
 */
@Mapper
public interface ProuctReglistrationRecordMapper {
    @Insert("insert into mes_wx_djz (\n" +
            "OBJUID,\n" +
            "serial_no,\n" +
            "fabrecordid,\n" +
            "item_no,\n" +
            "partid,\n" +
            "jx,\n" +
            "th,\n" +
            "processing_num,\n" +
            "job_num,\n" +
            "sending_date,\n" +
            "lph,\n" +
            "clphzt,\n" +
            "material_spec,\n" +
            "process_bc,\n" +
            "the_user,\n" +
            "the_date,\n" +
            "factory_id,\n" +
            "pass_number,\n" +
            "qualified_number,\n" +
            "concessions_taste, \n" +
            "waste_num, \n" +
            "supplier, \n" +
            "returned_type \n" +
            ") values (\n" +
            "#{objuid,jdbcType=VARCHAR},\n" +
            " serialno.nextval,\n" +
            "#{fabrecordid,jdbcType=VARCHAR},\n" +
            "#{xmh,jdbcType=VARCHAR},\n" +
            "#{partName,jdbcType=VARCHAR},\n" +
            "#{jx,jdbcType=VARCHAR},\n" +
            "#{partid,jdbcType=VARCHAR},\n" +
            "#{putnum,jdbcType=INTEGER},\n" +
            "#{pgh2,jdbcType=VARCHAR},\n" +
            "#{faliaoyuandate,jdbcType=VARCHAR},\n" +
            "#{lupihao,jdbcType=INTEGER},\n" +
            "#{materialmark,jdbcType=INTEGER},\n" +
            "#{materialfmt,jdbcType=VARCHAR},\n" +
            "#{gongyiver,jdbcType=VARCHAR},\n" +
            "#{theUser,jdbcType=VARCHAR},\n" +
            "sysdate,\n" +
            "#{factoryId,jdbcType=VARCHAR},\n" +
            "#{passNumber,jdbcType=VARCHAR},\n" +
            "#{qualifiedNumber,jdbcType=VARCHAR},\n" +
            "#{concessionsTaste,jdbcType=VARCHAR},\n" +
            "#{wasteNum,jdbcType=VARCHAR},\n" +
            "#{supplier,jdbcType=VARCHAR},\n" +
            "#{returnedType,jdbcType=VARCHAR}\n" +
            ")")
    int insert(ProductionReglstrationRecordDO productionReglstrationRecordDO);



}
